from django.db import models


# Create your models here.


class Student(models.Model):
	id = models.AutoField(primary_key=True)
	name = models.CharField(max_length=20)
	gender = models.CharField(max_length=6)
	birth = models.DateField()
	session = models.CharField(max_length=4)  # 某届
	class_s = models.CharField(max_length=4)
	
	class Meta:
		managed = True
		db_table = 'student'


class Group(models.Model):
	id = models.AutoField(primary_key=True)
	name = models.CharField(max_length=200)
	parent_id = models.FloatField()
	order_id = models.FloatField()
	sts = models.CharField(max_length=20, default='VALID')
	
	class Meta:
		managed = True
		db_table = 'group'
